Exact Financials

CC_MAIN_CLASS

CC_MAIN_CLASS (main_class_cd,cc,co,FY,period,balance_type,value,calc,model)

By using this function, you can include amounts of a cost center classification in the worksheet.

Note that a range of cost centers can be entered by separating the cost centers with a colon (:).

Example

CC_MAIN_CLASS(020,ADMI,621,2002,1,1,3,1,1)

As a result of the above function, the debit balance of the cost centers of main classification 020, financial year 2002 are included in the worksheet.

Parameters

Description	Explanation	Value
balance_type	Amounts that are posted.	1
value	The debit total.	1
	The credit total.	2
	The balance.	3
	The total of values is only shown when it is positive (debit).	4
	The total of values is only shown when it is negative (credit).	5
	The quantity (entered on a cost center) is included.	6
calc	Only the selected period is used.	1
calc	The amount is the cumulative amount up to and including the selected period.	2
model	This parameter should always be 1.	1

See also:

[Alphabetical overview of parameters]

Excel Add-in Manual > Contents > Functions > CC_MAIN_CLASS

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security level:	All - 0
Sub category:	Details	Document ID:	18.314.657
Assortment:	Exact Financials	Date:	01-12-2008
Release:		Attachment:
Disclaimer